Análise de Dados com Python

Desafio:

Você trabalha em uma empresa de telecom e tem clientes de vários serviços diferentes, entre os principais: internet e telefone.

O problema é que, analisando o histórico dos clientes dos últimos anos, você percebeu que a empresa está com Churn de mais de 26% dos clientes.

Isso representa uma perda de milhões para a empresa.

O que a empresa precisa fazer para resolver isso?

Base de Dados: https://drive.google.com/drive/folders/1T7D0BlWkNuy_MDpUHuBG44kT80EmRYIs?usp=sharing
Link Original do Kaggle: https://www.kaggle.com/radmirzosimov/telecom-users-dataset

In [1]:
IDCliente Genero Aposentado Casado Dependentes MesesComoCliente ServicoTelefone MultiplasLinhas ServicoInternet ServicoSegurancaOnline ... ServicoSuporteTecnico ServicoStreamingTV ServicoFilmes TipoContrato FaturaDigital FormaPagamento ValorMensal TotalGasto Churn Codigo
0 7010-BRBUU Masculino 0 Sim Sim 72 Sim Sim Nao SemInternet ... SemInternet SemInternet SemInternet 2 anos Nao CartaoCredito 24.10 1734.65 Nao NaN
1 9688-YGXVR Feminino 0 Nao Nao 44 Sim Nao Fibra Nao ... Nao Sim Nao Mensal Sim CartaoCredito 88.15 3973.2 Nao NaN
2 9286-DOJGF Feminino 1 Sim Nao 38 Sim Sim Fibra Nao ... Nao Nao Nao Mensal Sim DebitoAutomatico 74.95 2869.85 Sim NaN
3 6994-KERXL Masculino 0 Nao Nao 4 Sim Nao DSL Nao ... Nao Nao Sim Mensal Sim BoletoEletronico 55.90 238.5 Nao NaN
4 2181-UAESM Masculino 0 Nao Nao 2 Sim Nao DSL Sim ... Nao Nao Nao Mensal Nao BoletoEletronico 53.45 119.5 Nao NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
5981 0684-AOSIH Masculino 0 Sim Nao 1 Sim Nao Fibra Sim ... Nao Sim Sim Mensal Sim BoletoEletronico 95.00 95 Sim NaN
5982 5982-PSMKW Feminino 0 Sim Sim 23 Sim Sim DSL Sim ... Sim Sim Sim 2 anos Sim CartaoCredito 91.10 2198.3 Nao NaN
5983 8044-BGWPI Masculino 0 Sim Sim 12 Sim Nao Nao SemInternet ... SemInternet SemInternet SemInternet Mensal Sim BoletoEletronico 21.15 306.05 Nao NaN
5984 7450-NWRTR Masculino 1 Nao Nao 12 Sim Sim Fibra Nao ... Nao Sim Sim Mensal Sim BoletoEletronico 99.45 1200.15 Sim NaN
5985 4795-UXVCJ Masculino 0 Nao Nao 26 Sim Nao Nao SemInternet ... SemInternet SemInternet SemInternet Anual Nao CartaoCredito 19.80 457.3 Nao NaN

5986 rows × 22 columns

In [2]:
<class 'pandas.core.frame.DataFrame'>
Int64Index: 5974 entries, 0 to 5985
Data columns (total 21 columns):
 #   Column                  Non-Null Count  Dtype  
---  ------                  --------------  -----  
 0   IDCliente               5974 non-null   object 
 1   Genero                  5974 non-null   object 
 2   Aposentado              5974 non-null   int64  
 3   Casado                  5974 non-null   object 
 4   Dependentes             5974 non-null   object 
 5   MesesComoCliente        5974 non-null   int64  
 6   ServicoTelefone         5974 non-null   object 
 7   MultiplasLinhas         5974 non-null   object 
 8   ServicoInternet         5974 non-null   object 
 9   ServicoSegurancaOnline  5974 non-null   object 
 10  ServicoBackupOnline     5974 non-null   object 
 11  ProtecaoEquipamento     5974 non-null   object 
 12  ServicoSuporteTecnico   5974 non-null   object 
 13  ServicoStreamingTV      5974 non-null   object 
 14  ServicoFilmes           5974 non-null   object 
 15  TipoContrato            5974 non-null   object 
 16  FaturaDigital           5974 non-null   object 
 17  FormaPagamento          5974 non-null   object 
 18  ValorMensal             5974 non-null   float64
 19  TotalGasto              5974 non-null   float64
 20  Churn                   5974 non-null   object 
dtypes: float64(2), int64(2), object(17)
memory usage: 1.0+ MB
None
In [3]:
Nao    4387
Sim    1587
Name: Churn, dtype: int64
Nao    73.4%
Sim    26.6%
Name: Churn, dtype: object
In [4]:
Requirement already satisfied: plotly in c:\users\paulo roberto\anaconda3\lib\site-packages (5.9.0)
Requirement already satisfied: tenacity>=6.2.0 in c:\users\paulo roberto\anaconda3\lib\site-packages (from plotly) (8.0.1)
7010-BRBUU9926-PJHDQ3062-ICYZQ6837-HAEVO1042-HFUCW0771-CHWSK8268-YDIXR1469-LBJQJ7013-PSXHK5614-DNZCE0769-MURVM2252-ISRNH7008-LZVOZ0516-OOHAR3021-VLNRJ0345-XMMUG5133-POWUA3566-CAAYU0839-JTCUD6838-YAUVY0401-WDBXM1952-DVVSW2001-EWBQU1976-AZZPJ2657-VPXTA8547-NSBBO6585-WCEWR4647-MUZON6630-UJZMY9881-VCZEP5453-AXEPF6621-NRZAK0244-LGNFY5135-GRQJV7989-AWGEH9272-LSVYH0862-PRCBS9972-VAFJJ7129-ACFOG9537-VHDTA3243-ZHOHY5872-OEQNH9546-CQJSU3009-JWMPU6711-FLDFB7854-EDSSA3313-QKNKB9139-WQQDY4250-ZBWLV1043-YCUTE8943-URTMR7112-OPOTK5276-KQWHG9651-GTSAQ2398-YPMUR7730-IUTDZ8010-EZLOU00.20.40.60.81
ChurnNaoSimIDClientecount
MasculinoFeminino050010001500200025003000
ChurnNaoSimGenerocount
−0.500.511.5010002000300040005000
ChurnNaoSimAposentadocount
SimNao05001000150020002500300035004000
ChurnNaoSimDependentescount
0102030405060700100200300400500
ChurnNaoSimMesesComoClientecount
SimNao010002000300040005000
ChurnNaoSimServicoTelefonecount
SimNaoSemTelefone05001000150020002500
ChurnNaoSimMultiplasLinhascount
NaoFibraDSL05001000150020002500
ChurnNaoSimServicoInternetcount
SemInternetNaoSim050010001500200025003000
ChurnNaoSimServicoSegurancaOnlinecount
SemInternetSimNao05001000150020002500
ChurnNaoSimServicoBackupOnlinecount
SemInternetSimNao05001000150020002500
ChurnNaoSimProtecaoEquipamentocount
SemInternetNaoSim050010001500200025003000
ChurnNaoSimServicoSuporteTecnicocount
SemInternetSimNao05001000150020002500
ChurnNaoSimServicoStreamingTVcount
SemInternetNaoSim0500100015002000
ChurnNaoSimServicoFilmescount
2 anosMensalAnual050010001500200025003000
ChurnNaoSimTipoContratocount
NaoSim0500100015002000250030003500
ChurnNaoSimFaturaDigitalcount
CartaoCreditoBoletoEletronicoDebitoAutomaticoBoletoImpresso0500100015002000
ChurnNaoSimFormaPagamentocount
204060801001200100200300400500
ChurnNaoSimValorMensalcount
01000200030004000500060007000800002004006008001000
ChurnNaoSimTotalGastocount
NaoSim050010001500200025003000350040004500
ChurnNaoSimChurncount
In [ ]:
In [ ]:
In [ ]:

Conclusões e Ações

Escreva aqui suas conclusões: